package com.studentscore.constants;


public interface Sqls {

    String[] columnNames = {"\u5e8f\u53f7","\u5b66\u751f\u0069\u0064", "\u5b66\u751f\u540d\u5b57","\u5b66\u79d1","\u6210\u7ee9",
            "\u8001\u5e08","\u8003\u8bd5\u65e5\u671f"};

    String sql_all = "SELECT * from student_grades;";

    String sql2_add = "insert into student_grades(id,name,subject,score,teacher,exam_date) values (0,?,?,?,?,?)";

    String sql3_delete = "delete from student_grades where id=?";

    String sql4_update = "update student_grades set name=?, subject=?, score=?,teacher=? ,exam_date=? where id=?";

}
